using System;
using System.Collections.Generic;
using System.Text;

namespace SIS.DAL.Utilities
{
    static public class DBStoredProcNames
    {
        public static readonly string UP_InsertUpdateSingleItem = "UserProfileInsertUpdateSingleItem";
        public static readonly string UP_ViewSingleItem = "UserProfileViewSingleItem";
        public static readonly string UP_SelectSingleItem = "UserProfileSelectSingleItem";

        public static readonly string UA_InsertUpdateSingleItem = "UserAccountInsertUpdateSingleItem";
        public static readonly string UA_ViewSingleItem = "UserAccountViewSingleItem";
        public static readonly string UA_SelectSingleItem = "UserAccountSelectSingleItem";
        public static readonly string UA_SelectSingleItemByEmail = "UserAccountSelectSingleItemByEmail";
        public static readonly string UA_SelectSingleItemByGUID = "UserAccountSelectSingleItemByGUID";
        public static readonly string UA_CheckEmail = "UserAccountCheckEmail";

        public static readonly string GetTopAdListingByCounterCode = "sp_GetTopAdListingByCounterCode";
        public static readonly string GetGalleryImageListing = "sp_GetGalleryImageListing";
        public static readonly string GetListing = "sp_GetListing";
        public static readonly string GetAdRemovalReasonListing = "sp_GetAdRemovalReasonListing";
        
        public static readonly string GetOccupationListing = "sp_GetOccupationListing";
        public static readonly string GetCategoryTypeListing = "sp_GetCategoryTypeListing";
        public static readonly string GetCategoryName = "sp_GetCategoryName";
        public static readonly string GetCategoryListing = "sp_GetCategoryListing";
        public static readonly string GetCurrencyListing = "sp_GetCurrencyListing";
        public static readonly string GetCountryListing = "sp_GetCountryListing";
        public static readonly string GetCityListing = "sp_GetCityListing";
        public static readonly string GetCityListingBySearchText = "sp_GetCityListingBySearchText";
        public static readonly string GetStateListing = "sp_GetStateListing";

        public static readonly string MP_SelectSingleItem = "MainPostAdsSelectSingleItem";
        public static readonly string MP_ConfirmationSelectSingleItem = "MainPostAdsConfirmationSelectSingleItem";
        public static readonly string MP_ConfirmationUpdateSingleItem = "MainPostAdsConfirmationUpdateSingleItem";
        public static readonly string MP_RemovalInsertUpdateSingleItem = "MainPostAdsRemovalInsertUpdateSingleItem";
        public static readonly string MP_RemovalSelectSingleItem = "MainPostAdsRemovalSelectSingleItem";
        public static readonly string MP_RemovalViewSelectSingleItem = "MainPostAdsRemovalViewSelectSingleItem";
        public static readonly string MP_ViewItemListByListingType = "MainPostAdsSelectItemListByListingType";
        
        public static readonly string MP_UserPostAdsSelectItemList = "UserPostAdsSelectItemList";
        public static readonly string MP_AdminPostAdsSelectItemList = "AdminPostAdsSelectItemList";
        public static readonly string MP_PostAdsSelectItemList = "PostAdsSelectItemList";

        public static readonly string EM_GetAdsCount = "EmailAddressStatusGetAdsCount";
        public static readonly string EM_IsValid = "EmailAddressStatusIsValid";

        public static readonly string EMS_InsertUpdateSingleItem = "EmailMessageStatusInsertUpdateSingleItem";
        public static readonly string EMS_SelectSingleItem = "EmailMessageStatusSelectSingleItem";
        
        public static readonly string RE_InsertUpdateSingleItem = "RealEstatePostAdsInsertUpdateSingleItem";
        public static readonly string RE_ViewSingleItem = "RealEstatePostAdsViewSingleItem";
        public static readonly string RE_SelectSingleItem = "RealEstatePostAdsSelectSingleItem";
        public static readonly string RE_ViewItemListByListingType = "RealEstatePostAdsSelectItemListByListingType";

        public static readonly string SS_InsertUpdateSingleItem = "StuffSalePostAdsInsertUpdateSingleItem";
        public static readonly string SS_ViewSingleItem = "StuffSalePostAdsViewSingleItem";
        public static readonly string SS_SelectSingleItem = "StuffSalePostAdsSelectSingleItem";
        public static readonly string SS_ViewItemListByListingType = "StuffSalePostAdsSelectItemListByListingType";

        public static readonly string JB_InsertUpdateSingleItem = "JobPostAdsInsertUpdateSingleItem";
        public static readonly string JB_ViewSingleItem = "JobPostAdsViewSingleItem";
        public static readonly string JB_SelectSingleItem = "JobPostAdsSelectSingleItem";
        public static readonly string JB_ViewItemListByListingType = "JobPostAdsSelectItemListByListingType";

        public static readonly string CM_InsertUpdateSingleItem = "CommunityPostAdsInsertUpdateSingleItem";
        public static readonly string CM_ViewSingleItem = "CommunityPostAdsViewSingleItem";
        public static readonly string CM_SelectSingleItem = "CommunityPostAdsSelectSingleItem";
        public static readonly string CM_ViewItemListByListingType = "CommunityPostAdsSelectItemListByListingType";

        public static readonly string MV_InsertUpdateSingleItem = "MotorVehiclePostAdsInsertUpdateSingleItem";
        public static readonly string MV_ViewSingleItem = "MotorVehiclePostAdsViewSingleItem";
        public static readonly string MV_SelectSingleItem = "MotorVehiclePostAdsSelectSingleItem";
        public static readonly string MV_ViewItemListByListingType = "MotorVehiclePostAdsSelectItemListByListingType";

        public static readonly string EV_InsertUpdateSingleItem = "EventPostAdsInsertUpdateSingleItem";
        public static readonly string EV_ViewSingleItem = "EventPostAdsViewSingleItem";
        public static readonly string EV_SelectSingleItem = "EventPostAdsSelectSingleItem";
        public static readonly string EV_ViewItemListByListingType = "EventPostAdsSelectItemListByListingType";

        public static readonly string BS_InsertUpdateSingleItem = "BusinessServicePostAdsInsertUpdateSingleItem";
        public static readonly string BS_ViewSingleItem = "BusinessServicePostAdsViewSingleItem";
        public static readonly string BS_SelectSingleItem = "BusinessServicePostAdsSelectSingleItem";
        public static readonly string BS_ViewItemListByListingType = "BusinessServicePostAdsSelectItemListByListingType";

        public static readonly string MainFileInsertUpdateSingleItem = "MainFileInsertUpdateSingleItem";
        public static readonly string FileInsertUpdateSingleItem = "FileInsertUpdateSingleItem";
        public static readonly string FileSelectItemList = "FileDetailSelectItemList";
        public static readonly string FileDeleteSingleItemByFileID = "FileDetailDeleteSingleItemByFileID";
    }
}
